Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerOrderID (FK)(PK) | A unique system assigned identifier for the CustomerOrder. | ID_ORD | Identity | integer | |
CustomerOrderLineItemSequenceNumber (FK)(PK) | A unique system assigned identifier for the LineItem within the confines of the CustomerOrder. | IC_OR_LTM | LineNumber | smallint | |
TransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | PaymentOnAccountLineItem(TR_LTM_PYAN) |
RetailTransactionLineItemSequenceNumber (FK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | PaymentOnAccountLineItem(TR_LTM_PYAN) |